home *** CD-ROM | disk | FTP | other *** search
/ PC Professionell 2005 February / PCpro_2005_02.ISO / files / opensource / A_Note_4.2.1 / setup.exe / {app} / Server Documents / createxml.php < prev    next >
Encoding:
PHP Script  |  2004-10-01  |  2.2 KB  |  53 lines
  1. <?php
  2. // Find every note and create the xml
  3.     $query="SELECT * FROM note WHERE userid='$userid'";
  4.     $reply = mysql_query ($query);
  5.     $num_result = mysql_num_rows ($reply);
  6.     
  7. // Did we find a user
  8.     if ($num_result == 0)    {
  9.         echo $xmlstart ."<info info=\"no notes\"/>";
  10.         exit;
  11.     }
  12.  
  13. // Create the xml header
  14.     echo $xmlstart ."<notes>";
  15.  
  16. // Add the notes to the xml
  17.     for ($i = 0; $i < $num_result; $i++)    {
  18.         echo "<note";    
  19.     // Data
  20.         echo " noteversion=\"" .mysql_result ($reply, $i, "noteversion") ."\"";    
  21.         echo " noteid=\"" .mysql_result ($reply, $i, "noteid") ."\"";
  22.         echo " alarmtime=\"" .mysql_result ($reply, $i, "alarmtime") ."\"";
  23.         echo " usealarm=\"" .mysql_result ($reply, $i, "usealarm") ."\"";
  24.         echo " title=\"" .mysql_result ($reply, $i, "title") ."\"";
  25.         echo " visible=\"" .mysql_result ($reply, $i, "visible") ."\"";
  26.         echo " notecolor=\"" .mysql_result ($reply, $i, "notecolor") ."\"";                        
  27.         echo " positionleft=\"" .mysql_result ($reply, $i, "positionleft") ."\"";        
  28.         echo " positiontop=\"" .mysql_result ($reply, $i, "positiontop") ."\"";        
  29.         echo " width=\"" .mysql_result ($reply, $i, "width") ."\"";        
  30.         echo " height=\"" .mysql_result ($reply, $i, "height") ."\"";        
  31.         echo " dockedleft=\"" .mysql_result ($reply, $i, "dockedleft") ."\"";                                        
  32.         echo " dockedtop=\"" .mysql_result ($reply, $i, "dockedtop") ."\"";                                        
  33.         echo " dockedright=\"" .mysql_result ($reply, $i, "dockedright") ."\"";                                        
  34.         echo " dockedbottom=\"" .mysql_result ($reply, $i, "dockedbottom") ."\"";                                        
  35.  
  36.         echo " slided-left=\"" .mysql_result ($reply, $i, "slided-left") ."\"";                                        
  37.         echo " slided-right=\"" .mysql_result ($reply, $i, "slided-right") ."\"";                                        
  38.         echo " slidepositionleft=\"" .mysql_result ($reply, $i, "slidepositionleft") ."\"";                                        
  39.         echo " slidepositiontop=\"" .mysql_result ($reply, $i, "slidepositiontop") ."\"";                                        
  40.         echo " slidepositionright=\"" .mysql_result ($reply, $i, "slidepositionright") ."\"";                                        
  41.         echo " slidepositionbottom=\"" .mysql_result ($reply, $i, "slidepositionbottom") ."\">";                                        
  42.  
  43.         echo " <text>" .mysql_result ($reply, $i, "text") ."</text>";
  44.  
  45.         echo "</note>";
  46.     }
  47.  
  48. // Add the end tag
  49. echo "</notes>";
  50.     
  51. ?>
  52.  
  53.